CREATE TABLE [dbo].[Publish_Message_Log]
(
[PublishMessageLogID] [numeric] (18, 0) NOT NULL IDENTITY(1, 1),
[PublishRequestID] [int] NOT NULL CONSTRAINT [DF_Publish_Message_Log_PublishRequestID] DEFAULT ((0)),
[PublishRequestDetailID] [int] NULL,
[MessageNumber] [int] NULL,
[MessageText] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MessageDateTime] [datetime] NOT NULL,
[Location] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PublishServerCode] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DisplayFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Publish_Message_Log_DisplayFlag] DEFAULT ('Y')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Publish_Message_Log] ADD CONSTRAINT [PK_Publish_Message_Log] PRIMARY KEY CLUSTERED ([PublishMessageLogID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Publish_Message_Log_PublishServerCode] ON [dbo].[Publish_Message_Log] ([PublishServerCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Publish_Message_Log] ADD CONSTRAINT [FK_Publish_Message_Log_Publish_Server_Ref] FOREIGN KEY ([PublishServerCode]) REFERENCES [dbo].[Publish_Server_Ref] ([PublishServerCode])
GO
GRANT REFERENCES ON  [dbo].[Publish_Message_Log] TO [IMIS]
GRANT SELECT ON  [dbo].[Publish_Message_Log] TO [IMIS]
GRANT INSERT ON  [dbo].[Publish_Message_Log] TO [IMIS]
GRANT DELETE ON  [dbo].[Publish_Message_Log] TO [IMIS]
GRANT UPDATE ON  [dbo].[Publish_Message_Log] TO [IMIS]
GO